SELECT FORMMAIN_1002."ID",FORMMAIN_1002.FIELD0012 assetNo,FORMMAIN_1002.FIELD0010 assetName,fl.SHOWVALUE as type,zq.SHOWVALUE as time FROM COL_SUMMARY 
LEFT JOIN FORMMAIN_1002 ON FORMMAIN_1002."ID" = COL_SUMMARY.FORM_RECORDID
LEFT JOIN CTP_ENUM_ITEM fl ON fl."ID" = FORMMAIN_1002.FIELD0015
LEFT JOIN CTP_ENUM_ITEM zq ON zq."ID" = FORMMAIN_1002.FIELD0004
WHERE COL_SUMMARY."ID" = '${id}'